﻿using System.Data.SqlClient;
using System.Data;

namespace ExpertMIS.Manage
{

    public class QuestionHelper
    {
        public DataTable GetQuestionList()
        {
            string sql = "SELECT e.F_OID,d.F_DomainName as domain,e.F_Name ,e.F_Gender ,e.F_Phone ,e.F_CellPhone,e.F_EMail FROM T_Exp_Expert e ,T_Exp_ExpertBelongDomain b,T_Exp_Domain d WHERE b.F_ExpertOID = e.F_OID AND d.F_OID = b.F_DomainOID";
            return QuestionHelper.GetDataTable(sql);
        }
    }
}